USE [influenza]
GO

/****** Object:  StoredProcedure [dbo].[SP_muestraSintomaPaciente]    Script Date: 01/14/2010 17:59:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SP_muestraSintomaPaciente]
@param varchar(100)
as
Begin
declare @qry VARCHAR(8000)

SET @qry='select b.sintoma 
          from aux_sintomas a 
		  left join cat_sintomas b on (a.id_sintoma = b.id_sintomas ) 
		  where a.id_registro ='+@param+' and a.id_decision = 1'

exec (@qry)

End
GO

